package onlyTest;

import org.apache.commons.io.FileUtils;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

/**
 * poi
 *导出excel
 * Created by zzy on 2017/12/30.
 */
public class PoiExpExcel {

    public static void main(String[] args) {
        String[] title={"id","name","sex"};
        //创建工作簿
        HSSFWorkbook workbook=new HSSFWorkbook();
        //创建一个工作表sheet
        HSSFSheet sheet=workbook.createSheet();
        //创建第一行
        HSSFRow row=sheet.createRow(0);
        HSSFCell cell=null;
        //表头
        for (int i=0;i<title.length;i++){
            cell=row.createCell(i);
            cell.setCellValue(title[i]);
        }
        //追加数据
        for (int i=1;i<=10;i++){
            HSSFRow nextRow=sheet.createRow(i);
            HSSFCell cell2=nextRow.createCell(0);
            cell2.setCellValue("a"+i);
            cell2=nextRow.createCell(1);
            cell2.setCellValue("user"+i);
            cell2=nextRow.createCell(2);
            cell2.setCellValue("男"+i);
        }
        //创建excel文件
        File file=new File("e:/poi_test.xls");
        try {
            file.createNewFile();
            FileOutputStream stream= FileUtils.openOutputStream(file);
            workbook.write(stream);
            stream.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
